An atomic transaction is an indivisible and irreducible series of database operations such that either all occur, or nothing occurs.

Consistency in database systems refers to the requirement that any given database transaction must change affected data only in allowed ways.

In database systems, isolation determines how transaction integrity is visible to other users and systems.

In database systems, durability is the ACID property which guarantees that transactions that have committed will survive permanently.

A transaction reads data written by a concurrent uncommitted transaction.

A data integrity problem in which one writer of data overwrites the changes of a different writer modifying the same data.

A transaction re-reads data it has previously read and finds that data has been modified by another transaction (that committed since the initial read).

A transaction re-executes a query returning a set of rows that satisfy a search condition and finds that the set of rows satisfying the condition has changed due to another recently-committed transaction.

The result of successfully committing a group of transactions is inconsistent with all possible orderings of running those transactions one at a time.

Multiversion concurrency control (MCC or MVCC), is a concurrency control method commonly used by database management systems to provide concurrent access to the database.

Record locking is the technique of preventing simultaneous access to data in a database, to prevent inconsistent results.

A deadlock is a state in which each member of a group is waiting for another member, including itself, to take action, such as sending a message or more commonly releasing a lock.